--Execute as sys
col segment_name format a30
col segment_type format a13

SELECT segment_name, segment_type, segment_subtype
FROM   dba_segments
WHERE  tablespace_name = 'LOB_TBS1'
AND    segment_type = 'LOBSEGMENT';
